Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SH_SID NUMBER No null 1 null YES YES YES
OBJ VARCHAR2(20) Yes null 2 null YES YES YES
STARTED_BY VARCHAR2(100) Yes null 3 null YES YES YES
STARTED_ON DATE Yes null 4 null YES YES YES
STARTED_ON_FY NUMBER Yes null 5 null YES YES YES
COMPLETED_BY VARCHAR2(100) Yes null 6 null YES YES YES
COMPLETED_ON DATE Yes null 7 null YES YES YES
CODE VARCHAR2(20) Yes null 8 null NO NO NO
STATUS VARCHAR2(100) Yes null 9 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_CUBE_ALL_ACTIVITIES VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_BEHAVE_SCI_FILES VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_ALL_INACTIVE_ACTIVITIES VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_SIII_COLL_INVESTIGATIONS VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_F_ANP VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_SIIC_INTAKE VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_SIII_INVESTIGATIONS VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_CUBE_SIII_INVESTIGATIONS VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_SIIC_THREAT_INV VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_CUBE_TIMES_INVESTIGATIONS VIEW QART V_OBJ_STATUS_HISTORY VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS TABLE
QART V_OBJ_STATUS_HISTORY VIEW QART MV_ACM_STATUS_HISTORY TABLE
NAME VALUE
CREATED 06-APR-23
LAST_DDL_TIME 06-APR-23
OWNER QART
VIEW_NAME V_OBJ_STATUS_HISTORY
TEXT_LENGTH 294
TEXT SELECT H.SID SH_SID,           H.OBJ,           H.STARTED_BY,           H.STARTED_ON,           H.STARTED_ON_FY,           H.COMPLETED_BY,           H.COMPLETED_ON,           S.CODE,           S.DISPLAY STATUS      FROM MV_ACM_STATUS_HISTORY H     INNER JOIN MV_ACM_STATUS S ON H.STATUS = S.SID
TEXT_VC SELECT H.SID SH_SID,           H.OBJ,           H.STARTED_BY,           H.STARTED_ON,           H.STARTED_ON_FY,           H.COMPLETED_BY,           H.COMPLETED_ON,           S.CODE,           S.DISPLAY STATUS      FROM MV_ACM_STATUS_HISTORY H     INNER JOIN MV_ACM_STATUS S ON H.STATUS = S.SID
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT